using System;
using System.Collections.Generic;
using System.Text;
using Shc.Sql;
using Shc.Json;
namespace CLZ.Data
{
	public static class TableViewEXWarehouseList
	{
		public const string Table = "View_EXWarehouseList";
		public const string EXWarehouseID = "EXWarehouseID";
		public const string WarehouseID = "WarehouseID";
		public const string BusinessID = "BusinessID";
		public const string ApproveStatusID = "ApproveStatusID";
		public const string EXDate = "EXDate";
		public const string Description = "Description";
		public const string Creater = "Creater";
		public const string CreatedBy = "CreatedBy";
		public const string Created = "Created";
		public const string Modified = "Modified";
		public const string ModifiedBy = "ModifiedBy";
		public const string ModifiedByID = "ModifiedByID";
		public const string EXWarehouseTypeID = "EXWarehouseTypeID";
		public const string ApproveStatusName = "ApproveStatusName";
		public const string EXWarehouseTypeName = "EXWarehouseTypeName";
	}
	
	[Serializable]
	public class BaseViewEXWarehouseList
		: IDbSessionEntity, IJsonClass
	{
		int m_EXWarehouseID;
		/// <summary>
        /// 
        /// </summary>
        public int EXWarehouseID
        {
            get { return m_EXWarehouseID; }
            set { m_EXWarehouseID = value; }
        }
		
		int? m_WarehouseID;
		/// <summary>
        /// 
        /// </summary>
        public int? WarehouseID
        {
            get { return m_WarehouseID; }
            set { m_WarehouseID = value; }
        }
		
		int m_BusinessID;
		/// <summary>
        /// 
        /// </summary>
        public int BusinessID
        {
            get { return m_BusinessID; }
            set { m_BusinessID = value; }
        }
		
		int m_ApproveStatusID;
		/// <summary>
        /// 
        /// </summary>
        public int ApproveStatusID
        {
            get { return m_ApproveStatusID; }
            set { m_ApproveStatusID = value; }
        }
		
		DateTime m_EXDate;
		/// <summary>
        /// 
        /// </summary>
        public DateTime EXDate
        {
            get { return m_EXDate; }
            set { m_EXDate = value; }
        }
		
		string m_Description;
		/// <summary>
        /// 
        /// </summary>
        public string Description
        {
            get { return m_Description; }
            set { m_Description = value; }
        }
		
		int m_Creater;
		/// <summary>
        /// 
        /// </summary>
        public int Creater
        {
            get { return m_Creater; }
            set { m_Creater = value; }
        }
		
		string m_CreatedBy;
		/// <summary>
        /// 
        /// </summary>
        public string CreatedBy
        {
            get { return m_CreatedBy; }
            set { m_CreatedBy = value; }
        }
		
		DateTime m_Created;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Created
        {
            get { return m_Created; }
            set { m_Created = value; }
        }
		
		DateTime m_Modified;
		/// <summary>
        /// 
        /// </summary>
        public DateTime Modified
        {
            get { return m_Modified; }
            set { m_Modified = value; }
        }
		
		string m_ModifiedBy;
		/// <summary>
        /// 
        /// </summary>
        public string ModifiedBy
        {
            get { return m_ModifiedBy; }
            set { m_ModifiedBy = value; }
        }
		
		int? m_ModifiedByID;
		/// <summary>
        /// 
        /// </summary>
        public int? ModifiedByID
        {
            get { return m_ModifiedByID; }
            set { m_ModifiedByID = value; }
        }
		
		int m_EXWarehouseTypeID;
		/// <summary>
        /// 
        /// </summary>
        public int EXWarehouseTypeID
        {
            get { return m_EXWarehouseTypeID; }
            set { m_EXWarehouseTypeID = value; }
        }
		
		string m_ApproveStatusName;
		/// <summary>
        /// 
        /// </summary>
        public string ApproveStatusName
        {
            get { return m_ApproveStatusName; }
            set { m_ApproveStatusName = value; }
        }
		
		string m_EXWarehouseTypeName;
		/// <summary>
        /// 
        /// </summary>
        public string EXWarehouseTypeName
        {
            get { return m_EXWarehouseTypeName; }
            set { m_EXWarehouseTypeName = value; }
        }
		
		
		#region IDbSessionEntity Members
		public void ReadDBData(RowDataReader reader)
        {
            m_EXWarehouseID = reader[TableViewEXWarehouseList.EXWarehouseID];
            m_WarehouseID = reader[TableViewEXWarehouseList.WarehouseID];
            m_BusinessID = reader[TableViewEXWarehouseList.BusinessID];
            m_ApproveStatusID = reader[TableViewEXWarehouseList.ApproveStatusID];
            m_EXDate = reader[TableViewEXWarehouseList.EXDate];
            m_Description = reader[TableViewEXWarehouseList.Description];
            m_Creater = reader[TableViewEXWarehouseList.Creater];
            m_CreatedBy = reader[TableViewEXWarehouseList.CreatedBy];
            m_Created = reader[TableViewEXWarehouseList.Created];
            m_Modified = reader[TableViewEXWarehouseList.Modified];
            m_ModifiedBy = reader[TableViewEXWarehouseList.ModifiedBy];
            m_ModifiedByID = reader[TableViewEXWarehouseList.ModifiedByID];
            m_EXWarehouseTypeID = reader[TableViewEXWarehouseList.EXWarehouseTypeID];
            m_ApproveStatusName = reader[TableViewEXWarehouseList.ApproveStatusName];
            m_EXWarehouseTypeName = reader[TableViewEXWarehouseList.EXWarehouseTypeName];
        }
		
		public void WriteDBData(RowDataWriter writer)
        {
        }

        public void SetIdentityAfterInsert(DBObject idd)
        {
        }
		
		public string TableName
        {
            get { return TableViewEXWarehouseList.Table; }
        }
		#endregion
		
		
		#region IJsonClass Members

        public void JsonDeSerializeObj(JsonHashTable hashToRead)
        {
             m_EXWarehouseID = hashToRead["EXWarehouseID"];
			 
             m_WarehouseID = hashToRead["WarehouseID"];
			 
             m_BusinessID = hashToRead["BusinessID"];
			 
             m_ApproveStatusID = hashToRead["ApproveStatusID"];
			 
             m_EXDate = hashToRead["EXDate"];
			 
             m_Description = hashToRead["Description"];
			 
             m_Creater = hashToRead["Creater"];
			 
             m_CreatedBy = hashToRead["CreatedBy"];
			 
             m_Created = hashToRead["Created"];
			 
             m_Modified = hashToRead["Modified"];
			 
             m_ModifiedBy = hashToRead["ModifiedBy"];
			 
             m_ModifiedByID = hashToRead["ModifiedByID"];
			 
             m_EXWarehouseTypeID = hashToRead["EXWarehouseTypeID"];
			 
             m_ApproveStatusName = hashToRead["ApproveStatusName"];
			 
             m_EXWarehouseTypeName = hashToRead["EXWarehouseTypeName"];
			 
        }

        public void JsonSerializeObj(JsonHashTable hashToFill)
        {
            hashToFill["EXWarehouseID"] = EXWarehouseID;
			
            hashToFill["WarehouseID"] = WarehouseID;
			
            hashToFill["BusinessID"] = BusinessID;
			
            hashToFill["ApproveStatusID"] = ApproveStatusID;
			
            hashToFill["EXDate"] = EXDate;
			
            hashToFill["Description"] = Description;
			
            hashToFill["Creater"] = Creater;
			
            hashToFill["CreatedBy"] = CreatedBy;
			
            hashToFill["Created"] = Created;
			
            hashToFill["Modified"] = Modified;
			
            hashToFill["ModifiedBy"] = ModifiedBy;
			
            hashToFill["ModifiedByID"] = ModifiedByID;
			
            hashToFill["EXWarehouseTypeID"] = EXWarehouseTypeID;
			
            hashToFill["ApproveStatusName"] = ApproveStatusName;
			
            hashToFill["EXWarehouseTypeName"] = EXWarehouseTypeName;
			
        }

        #endregion
		
	}
}
